Users can create PQL formulas from the Content panel by selecting the required functions from the drop down lists. The selected dynamic property is then based on the formula, rather than static values. This provides users with a tremendous amount of flexibility and control over the behavior of dynamic assets.
- The PQL functions for dynamic graphics and text are exposed via the common library and the dynamic library.
How to Build Dynamic PQL Formulas
Select the required function(s) from the drop down menus. Then add the relevant data to the expression simply by selecting it in the grid. For instance, to add a <value_set>, select a set of cells that contain values.
Review the following list to understand how each parameter relates to the grid:
|
caption |
Click-select a row or column caption (header), or write the caption contained within quotation marks. |
|
column |
Click a column number from the grid. |
|
criteria |
Select a row or column caption (header). |
|
criteria_set |
Write the index of criteria, contained within quotation marks, followed by = and a result. For example (Criteria("Purached Bike"="Yes","Purchased Bike"="No"). |
|
default_value |
Write a default numeric value. |
|
if_false |
Write a string, contained within quotation marks. For example, "Up". |
|
if_true |
Write a string, contained within quotation marks. For example, "Down". |
|
index |
Click a row or column number. |
|
isCaseSensitive |
Write either "true" or "false" depending on whether or not the given caption is case sensitive. |
|
outcome_set |
Write the index of outcomes (the results that should be returned when the corresponding criteria from the criteria_set index is met, (contained within quotation marks. For example, CriteriaResults("Cyclist", "Potential"), "na"). |
|
percent |
Write a number between 0 and 1. For example, 0.6. |
|
row |
Click a row number from the grid. |
|
value |
Select a cell containing a numeric value. |
|
value_set |
Select a set of values by clicking cells that contain numeric values. |
|
() |
Some functions end with empty brackets (like numberOfColumns, numberOfRows, and numberOfCells). The brackets should be left as they are. |
Example: Dynamic Text based on a Dynamic Function
In the following example, we want to configure dynamic text that show the average cost for Accessories, in a currency format with no decimal places.
The first step is to add the average function from the queries drop down:
Next, highlight the average function and select Currency ($#) from the formats drop down. The average function will be inserted into the format function:
Next, remove [<value_set>] and replace it with the set of values for which the average should be returned. To do this, simply click the relevant cells (blue highlight), and separate each of them with a comma:
